create table if not exists d_enp_ppm_iagw_business_h_#{PARTITION_DATE}
 (
ismpj01    datetime ,
ismpj02    datetime ,
ismpj03    varchar(128) ,
ismpj04    varchar(64) ,
ismpj05    varchar(64) ,
ismpj06    varchar(64) ,
ismpj07    varchar(64) ,
ismpj08    varchar(64) ,
ismpj09    bigint ,
ismpj10    bigint ,
ismpj11    double ,
ismpj12    bigint ,
ismpj13    bigint ,
ismpj14    double ,
ismpj15    bigint ,
ismpj16    bigint ,
ismpj17    bigint ,
ismpj18    bigint ,
ismpj19    double ,
ismpj20    bigint ,
ismpj21    bigint ,
ismpj22    double ,
ismpj23    bigint ,
ismpj24    bigint ,
ismpj25    double ,
ismpj26    double ,
ismpj27    bigint ,
ismpj28    bigint ,
ismpj29    bigint ,
ismpj30    bigint ,
ismpj31    double ,
ismpj32    varchar(10)
)   compress(5, 5)  nolock ;